<?php
/**
* file encoding utf-8
* 文件字符编码utf-8
*/
$PathToRongFramework = dirname(__FILE__)."/../lib"; //指向 名字为“Rong”的文件夹的父目录。
set_include_path( "." . PATH_SEPARATOR . $PathToRongFramework . PATH_SEPARATOR . get_include_path() );
require_once 'Rong/Db.php';
require_once "Rong/Html/PageLink.php";
$db = Rong_Db::factory("Mysql", array(
"host" => "localhost", //mysql 主机
"username" => "root", //用户名
"password" => "123456", //密码
"dbname" => "rong_db", //数据库名称
"charset" => "utf8" //字符集,也可以是gbk gb2312 ansii等
));
$page = intval( @$_GET["page"] ); //当前页码
$pageSize = 2; //页面大小
$urlTemplate = "db_paginator.php?page={Page}&size={PageSize}"; //分页链接的模板,“{Page}”表示页码,“{PageSize}”表示分页大小。
$sql = "select * from w_article"; //要分页的sql
$rs = $db->getPaginator($sql, $page, $pageSize, $urlTemplate ); //执行分页
//输出分页的数据
echo "<table border=1>";
echo "<tr> <th>编号</th> <th>标题</th> <th>内容</th> <th>添加时间</th> </tr>";
for( $i=0; $i< count($rs["Data"]); $i++ )
{
$row = $rs["Data"][$i];
echo "<tr>";
echo "<td>" . $row["id"] . "</td>";
echo "<td>" . $row["title"] . "</td>";
echo "<td>" . $row["content"] . "</td>";
echo "<td>" . $row["add_time"] . "</td>";
echo "</tr>";
}
echo "</table>";
//输出分类的链接
echo $rs["PaginatorHtml"];
echo "<h3>分页时返回的数据</h3>";
echo "<pre>";
print_r( $rs );
echo "</pre>";